/*
 * Copyright (c) 2017 <l_iupeiyu@qq.com> All rights reserved.
 */

package com.gzwh.v1.sysapi.dao.member;


import com.gzwh.v1.sysapi.entity.UserBean;
import com.gzwh.v1.sysapi.entity.member.SFMemberEntity;
import com.gzwh.v1.sysapi.utils.CustomerMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Service;

/**
 * author geekcattle
 * date 2016/10/21 0021 下午 15:32
 */
@Mapper
public interface MemberMapper extends CustomerMapper<SFMemberEntity> {

    UserBean selectByUsername(String username);

    SFMemberEntity selectSFMemberByName(String name);

    SFMemberEntity selectSFMemberByMail(String mail);

    @Select("select count(*) from sf_member where is_lock=0")
    int verUserStatus(@Param("uid")Long uid);
}
